Dataset statistics
| Number of variables | 70 |
|---|---|
| Number of observations | 260601 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 73.1 MiB |
| Average record size in memory | 294.0 B |
Variable types
| BOOL | 60 |
|---|---|
| NUM | 9 |
| CAT | 1 |
building_id has unique values | Unique |
geo_level_1_id has 4011 (1.5%) zeros | Zeros |
age has 26041 (10.0%) zeros | Zeros |
count_families has 20862 (8.0%) zeros | Zeros |
Reproduction
| Analysis started | 2020-09-29 03:17:06.759523 |
|---|---|
| Analysis finished | 2020-09-29 03:19:35.431822 |
| Duration | 2 minutes and 28.67 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 260601 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 525675.4828 |
|---|---|
| Minimum | 4 |
| Maximum | 1052934 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 52114 |
| Q1 | 261190 |
| median | 525757 |
| Q3 | 789762 |
| 95-th percentile | 1000724 |
| Maximum | 1052934 |
| Range | 1052930 |
| Interquartile range (IQR) | 528572 |
Descriptive statistics
| Standard deviation | 304544.999 |
|---|---|
| Coefficient of variation (CV) | 0.5793403136 |
| Kurtosis | -1.203878964 |
| Mean | 525675.4828 |
| Median Absolute Deviation (MAD) | 264277 |
| Skewness | 0.001882356737 |
| Sum | 1.369915565e+11 |
| Variance | 9.274765644e+10 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1052670 | 1 | < 0.1% | |
| 847304 | 1 | < 0.1% | |
| 368102 | 1 | < 0.1% | |
| 729986 | 1 | < 0.1% | |
| 900578 | 1 | < 0.1% | |
| 896480 | 1 | < 0.1% | |
| 808415 | 1 | < 0.1% | |
| 812505 | 1 | < 0.1% | |
| 290264 | 1 | < 0.1% | |
| 269782 | 1 | < 0.1% | |
| Other values (260591) | 260591 | > 99.9% |
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1052934 | 1 | < 0.1% | |
| 1052931 | 1 | < 0.1% | |
| 1052929 | 1 | < 0.1% | |
| 1052926 | 1 | < 0.1% | |
| 1052921 | 1 | < 0.1% |
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.90035341 |
|---|---|
| Minimum | 0 |
| Maximum | 30 |
| Zeros | 4011 |
| Zeros (%) | 1.5% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 7 |
| median | 12 |
| Q3 | 21 |
| 95-th percentile | 27 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.033616625 |
|---|---|
| Coefficient of variation (CV) | 0.5779433361 |
| Kurtosis | -1.213248785 |
| Mean | 13.90035341 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.2725303548 |
| Sum | 3622446 |
| Variance | 64.53899608 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 24381 | 9.4% | |
| 26 | 22615 | 8.7% | |
| 10 | 22079 | 8.5% | |
| 17 | 21813 | 8.4% | |
| 8 | 19080 | 7.3% | |
| 7 | 18994 | 7.3% | |
| 20 | 17216 | 6.6% | |
| 21 | 14889 | 5.7% | |
| 4 | 14568 | 5.6% | |
| 27 | 12532 | 4.8% | |
| Other values (21) | 72434 | 27.8% |
| Value | Count | Frequency (%) | |
| 0 | 4011 | 1.5% | |
| 1 | 2701 | 1.0% | |
| 2 | 931 | 0.4% | |
| 3 | 7540 | 2.9% | |
| 4 | 14568 | 5.6% |
| Value | Count | Frequency (%) | |
| 30 | 2686 | 1.0% | |
| 29 | 396 | 0.2% | |
| 28 | 265 | 0.1% | |
| 27 | 12532 | 4.8% | |
| 26 | 22615 | 8.7% |
geo_level_2_id
Real number (ℝ≥0)
| Distinct | 1414 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 701.0746851 |
|---|---|
| Minimum | 0 |
| Maximum | 1427 |
| Zeros | 38 |
| Zeros (%) | < 0.1% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 69 |
| Q1 | 350 |
| median | 702 |
| Q3 | 1050 |
| 95-th percentile | 1377 |
| Maximum | 1427 |
| Range | 1427 |
| Interquartile range (IQR) | 700 |
Descriptive statistics
| Standard deviation | 412.7107336 |
|---|---|
| Coefficient of variation (CV) | 0.5886829782 |
| Kurtosis | -1.188232475 |
| Mean | 701.0746851 |
| Median Absolute Deviation (MAD) | 349 |
| Skewness | 0.02895738139 |
| Sum | 182700764 |
| Variance | 170330.1496 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 39 | 4038 | 1.5% | |
| 158 | 2520 | 1.0% | |
| 181 | 2080 | 0.8% | |
| 1387 | 2040 | 0.8% | |
| 157 | 1897 | 0.7% | |
| 363 | 1760 | 0.7% | |
| 463 | 1740 | 0.7% | |
| 673 | 1704 | 0.7% | |
| 533 | 1684 | 0.6% | |
| 883 | 1626 | 0.6% | |
| Other values (1404) | 239512 | 91.9% |
| Value | Count | Frequency (%) | |
| 0 | 38 | < 0.1% | |
| 1 | 204 | 0.1% | |
| 3 | 77 | < 0.1% | |
| 4 | 315 | 0.1% | |
| 5 | 25 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1427 | 6 | < 0.1% | |
| 1426 | 286 | 0.1% | |
| 1425 | 466 | 0.2% | |
| 1424 | 7 | < 0.1% | |
| 1423 | 3 | < 0.1% |
geo_level_3_id
Real number (ℝ≥0)
| Distinct | 11595 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6257.876148 |
|---|---|
| Minimum | 0 |
| Maximum | 12567 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 611 |
| Q1 | 3073 |
| median | 6270 |
| Q3 | 9412 |
| 95-th percentile | 11927 |
| Maximum | 12567 |
| Range | 12567 |
| Interquartile range (IQR) | 6339 |
Descriptive statistics
| Standard deviation | 3646.369645 |
|---|---|
| Coefficient of variation (CV) | 0.5826848532 |
| Kurtosis | -1.213896506 |
| Mean | 6257.876148 |
| Median Absolute Deviation (MAD) | 3171 |
| Skewness | 0.0003935120899 |
| Sum | 1630808782 |
| Variance | 13296011.59 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 633 | 651 | 0.2% | |
| 9133 | 647 | 0.2% | |
| 621 | 530 | 0.2% | |
| 11246 | 470 | 0.2% | |
| 2005 | 466 | 0.2% | |
| 11440 | 455 | 0.2% | |
| 7723 | 443 | 0.2% | |
| 9229 | 381 | 0.1% | |
| 2452 | 349 | 0.1% | |
| 12258 | 312 | 0.1% | |
| Other values (11585) | 255897 | 98.2% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 6 | < 0.1% | |
| 3 | 9 | < 0.1% | |
| 5 | 14 | < 0.1% | |
| 6 | 21 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12567 | 1 | < 0.1% | |
| 12565 | 7 | < 0.1% | |
| 12564 | 6 | < 0.1% | |
| 12563 | 24 | < 0.1% | |
| 12562 | 3 | < 0.1% |
count_floors_pre_eq
Real number (ℝ≥0)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.129723217 |
|---|---|
| Minimum | 1 |
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7276645453 |
|---|---|
| Coefficient of variation (CV) | 0.3416709456 |
| Kurtosis | 2.322597881 |
| Mean | 2.129723217 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.8341129586 |
| Sum | 555008 |
| Variance | 0.5294956905 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 156623 | 60.1% | |
| 3 | 55617 | 21.3% | |
| 1 | 40441 | 15.5% | |
| 4 | 5424 | 2.1% | |
| 5 | 2246 | 0.9% | |
| 6 | 209 | 0.1% | |
| 7 | 39 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 40441 | 15.5% | |
| 2 | 156623 | 60.1% | |
| 3 | 55617 | 21.3% | |
| 4 | 5424 | 2.1% | |
| 5 | 2246 | 0.9% |
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 39 | < 0.1% | |
| 6 | 209 | 0.1% | |
| 5 | 2246 | 0.9% |
| Distinct | 42 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.53502865 |
|---|---|
| Minimum | 0 |
| Maximum | 995 |
| Zeros | 26041 |
| Zeros (%) | 10.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| median | 15 |
| Q3 | 30 |
| 95-th percentile | 60 |
| Maximum | 995 |
| Range | 995 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 73.56593652 |
|---|---|
| Coefficient of variation (CV) | 2.772408408 |
| Kurtosis | 157.2482363 |
| Mean | 26.53502865 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 12.19249422 |
| Sum | 6915055 |
| Variance | 5411.947016 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 38896 | 14.9% | |
| 15 | 36010 | 13.8% | |
| 5 | 33697 | 12.9% | |
| 20 | 32182 | 12.3% | |
| 0 | 26041 | 10.0% | |
| 25 | 24366 | 9.3% | |
| 30 | 18028 | 6.9% | |
| 35 | 10710 | 4.1% | |
| 40 | 10559 | 4.1% | |
| 50 | 7257 | 2.8% | |
| Other values (32) | 22855 | 8.8% |
| Value | Count | Frequency (%) | |
| 0 | 26041 | 10.0% | |
| 5 | 33697 | 12.9% | |
| 10 | 38896 | 14.9% | |
| 15 | 36010 | 13.8% | |
| 20 | 32182 | 12.3% |
| Value | Count | Frequency (%) | |
| 995 | 1390 | 0.5% | |
| 200 | 106 | < 0.1% | |
| 195 | 2 | < 0.1% | |
| 190 | 3 | < 0.1% | |
| 185 | 1 | < 0.1% |
area_percentage
Real number (ℝ≥0)
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.018050583 |
|---|---|
| Minimum | 1 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 16 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 4.392230936 |
|---|---|
| Coefficient of variation (CV) | 0.5477928694 |
| Kurtosis | 30.43825794 |
| Mean | 8.018050583 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 3.526082314 |
| Sum | 2089512 |
| Variance | 19.29169259 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 42013 | 16.1% | |
| 7 | 36752 | 14.1% | |
| 5 | 32724 | 12.6% | |
| 8 | 28445 | 10.9% | |
| 9 | 22199 | 8.5% | |
| 4 | 19236 | 7.4% | |
| 10 | 15613 | 6.0% | |
| 11 | 13907 | 5.3% | |
| 3 | 11837 | 4.5% | |
| 12 | 7581 | 2.9% | |
| Other values (74) | 30294 | 11.6% |
| Value | Count | Frequency (%) | |
| 1 | 90 | < 0.1% | |
| 2 | 3181 | 1.2% | |
| 3 | 11837 | 4.5% | |
| 4 | 19236 | 7.4% | |
| 5 | 32724 | 12.6% |
| Value | Count | Frequency (%) | |
| 100 | 1 | < 0.1% | |
| 96 | 3 | < 0.1% | |
| 90 | 1 | < 0.1% | |
| 86 | 5 | < 0.1% | |
| 85 | 4 | < 0.1% |
height_percentage
Real number (ℝ≥0)
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.434365179 |
|---|---|
| Minimum | 2 |
| Maximum | 32 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 5 |
| Q3 | 6 |
| 95-th percentile | 9 |
| Maximum | 32 |
| Range | 30 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.918418221 |
|---|---|
| Coefficient of variation (CV) | 0.3530160667 |
| Kurtosis | 14.31852616 |
| Mean | 5.434365179 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.808261757 |
| Sum | 1416201 |
| Variance | 3.68032847 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 5 | 78513 | 30.1% | |
| 6 | 46477 | 17.8% | |
| 4 | 37763 | 14.5% | |
| 7 | 35465 | 13.6% | |
| 3 | 25957 | 10.0% | |
| 8 | 13902 | 5.3% | |
| 2 | 9305 | 3.6% | |
| 9 | 5376 | 2.1% | |
| 10 | 4492 | 1.7% | |
| 11 | 917 | 0.4% | |
| Other values (17) | 2434 | 0.9% |
| Value | Count | Frequency (%) | |
| 2 | 9305 | 3.6% | |
| 3 | 25957 | 10.0% | |
| 4 | 37763 | 14.5% | |
| 5 | 78513 | 30.1% | |
| 6 | 46477 | 17.8% |
| Value | Count | Frequency (%) | |
| 32 | 75 | < 0.1% | |
| 31 | 1 | < 0.1% | |
| 28 | 2 | < 0.1% | |
| 26 | 2 | < 0.1% | |
| 25 | 3 | < 0.1% |
has_superstructure_adobe_mud
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 23101 |
| Value | Count | Frequency (%) | |
| 0 | 237500 | 91.1% | |
| 1 | 23101 | 8.9% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 198561 | 76.2% | |
| 0 | 62040 | 23.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 8947 |
| Value | Count | Frequency (%) | |
| 0 | 251654 | 96.6% | |
| 1 | 8947 | 3.4% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 4752 |
| Value | Count | Frequency (%) | |
| 0 | 255849 | 98.2% | |
| 1 | 4752 | 1.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 17761 |
| Value | Count | Frequency (%) | |
| 0 | 242840 | 93.2% | |
| 1 | 17761 | 6.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 19615 |
| Value | Count | Frequency (%) | |
| 0 | 240986 | 92.5% | |
| 1 | 19615 | 7.5% |
has_superstructure_timber
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 194151 | 74.5% | |
| 1 | 66450 | 25.5% |
has_superstructure_bamboo
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 22154 |
| Value | Count | Frequency (%) | |
| 0 | 238447 | 91.5% | |
| 1 | 22154 | 8.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 11099 |
| Value | Count | Frequency (%) | |
| 0 | 249502 | 95.7% | |
| 1 | 11099 | 4.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 4133 |
| Value | Count | Frequency (%) | |
| 0 | 256468 | 98.4% | |
| 1 | 4133 | 1.6% |
has_superstructure_other
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 3905 |
| Value | Count | Frequency (%) | |
| 0 | 256696 | 98.5% | |
| 1 | 3905 | 1.5% |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9839486418 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros | 20862 |
| Zeros (%) | 8.0% |
| Memory size | 2.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4183889779 |
|---|---|
| Coefficient of variation (CV) | 0.425214244 |
| Kurtosis | 17.67094319 |
| Mean | 0.9839486418 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.634757873 |
| Sum | 256418 |
| Variance | 0.1750493368 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 226115 | 86.8% | |
| 0 | 20862 | 8.0% | |
| 2 | 11294 | 4.3% | |
| 3 | 1802 | 0.7% | |
| 4 | 389 | 0.1% | |
| 5 | 104 | < 0.1% | |
| 6 | 22 | < 0.1% | |
| 7 | 7 | < 0.1% | |
| 9 | 4 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 20862 | 8.0% | |
| 1 | 226115 | 86.8% | |
| 2 | 11294 | 4.3% | |
| 3 | 1802 | 0.7% | |
| 4 | 389 | 0.1% |
| Value | Count | Frequency (%) | |
| 9 | 4 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 7 | < 0.1% | |
| 6 | 22 | < 0.1% | |
| 5 | 104 | < 0.1% |
has_secondary_use
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 231445 | 88.8% | |
| 1 | 29156 | 11.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 16777 |
| Value | Count | Frequency (%) | |
| 0 | 243824 | 93.6% | |
| 1 | 16777 | 6.4% |
has_secondary_use_hotel
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 8763 |
| Value | Count | Frequency (%) | |
| 0 | 251838 | 96.6% | |
| 1 | 8763 | 3.4% |
has_secondary_use_rental
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 2111 |
| Value | Count | Frequency (%) | |
| 0 | 258490 | 99.2% | |
| 1 | 2111 | 0.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 245 |
| Value | Count | Frequency (%) | |
| 0 | 260356 | 99.9% | |
| 1 | 245 | 0.1% |
has_secondary_use_school
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 94 |
| Value | Count | Frequency (%) | |
| 0 | 260507 | > 99.9% | |
| 1 | 94 | < 0.1% |
has_secondary_use_industry
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 279 |
| Value | Count | Frequency (%) | |
| 0 | 260322 | 99.9% | |
| 1 | 279 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 49 |
| Value | Count | Frequency (%) | |
| 0 | 260552 | > 99.9% | |
| 1 | 49 | < 0.1% |
has_secondary_use_gov_office
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 38 |
| Value | Count | Frequency (%) | |
| 0 | 260563 | > 99.9% | |
| 1 | 38 | < 0.1% |
has_secondary_use_use_police
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 23 |
| Value | Count | Frequency (%) | |
| 0 | 260578 | > 99.9% | |
| 1 | 23 | < 0.1% |
has_secondary_use_other
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 0 | |
|---|---|
| 1 | 1334 |
| Value | Count | Frequency (%) | |
| 0 | 259267 | 99.5% | |
| 1 | 1334 | 0.5% |
damage_grade
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.0 MiB |
| 2 | |
|---|---|
| 3 | |
| 1 |
| Value | Count | Frequency (%) | |
| 2 | 148259 | 56.9% | |
| 3 | 87218 | 33.5% | |
| 1 | 25124 | 9.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
land_surface_condition_n
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 225073 | 86.4% | |
| 1 | 35528 | 13.6% |
land_surface_condition_o
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 8316 |
| Value | Count | Frequency (%) | |
| 0 | 252285 | 96.8% | |
| 1 | 8316 | 3.2% |
land_surface_condition_t
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 216757 | 83.2% | |
| 0 | 43844 | 16.8% |
foundation_type_h
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 1448 |
| Value | Count | Frequency (%) | |
| 0 | 259153 | 99.4% | |
| 1 | 1448 | 0.6% |
foundation_type_i
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 10579 |
| Value | Count | Frequency (%) | |
| 0 | 250022 | 95.9% | |
| 1 | 10579 | 4.1% |
foundation_type_r
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 219196 | 84.1% | |
| 0 | 41405 | 15.9% |
foundation_type_u
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 14260 |
| Value | Count | Frequency (%) | |
| 0 | 246341 | 94.5% | |
| 1 | 14260 | 5.5% |
foundation_type_w
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 15118 |
| Value | Count | Frequency (%) | |
| 0 | 245483 | 94.2% | |
| 1 | 15118 | 5.8% |
roof_type_n
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 182842 | 70.2% | |
| 0 | 77759 | 29.8% |
roof_type_q
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 199025 | 76.4% | |
| 1 | 61576 | 23.6% |
roof_type_x
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 16183 |
| Value | Count | Frequency (%) | |
| 0 | 244418 | 93.8% | |
| 1 | 16183 | 6.2% |
ground_floor_type_f
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 209619 | 80.4% | |
| 0 | 50982 | 19.6% |
ground_floor_type_m
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 508 |
| Value | Count | Frequency (%) | |
| 0 | 260093 | 99.8% | |
| 1 | 508 | 0.2% |
ground_floor_type_v
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 236008 | 90.6% | |
| 1 | 24593 | 9.4% |
ground_floor_type_x
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 235724 | 90.5% | |
| 1 | 24877 | 9.5% |
ground_floor_type_z
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 1004 |
| Value | Count | Frequency (%) | |
| 0 | 259597 | 99.6% | |
| 1 | 1004 | 0.4% |
other_floor_type_j
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 220758 | 84.7% | |
| 1 | 39843 | 15.3% |
other_floor_type_q
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 165282 | 63.4% | |
| 0 | 95319 | 36.6% |
other_floor_type_s
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 12028 |
| Value | Count | Frequency (%) | |
| 0 | 248573 | 95.4% | |
| 1 | 12028 | 4.6% |
other_floor_type_x
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 217153 | 83.3% | |
| 1 | 43448 | 16.7% |
position_j
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 13282 |
| Value | Count | Frequency (%) | |
| 0 | 247319 | 94.9% | |
| 1 | 13282 | 5.1% |
position_o
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 2333 |
| Value | Count | Frequency (%) | |
| 0 | 258268 | 99.1% | |
| 1 | 2333 | 0.9% |
position_s
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 202090 | 77.5% | |
| 0 | 58511 | 22.5% |
position_t
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 217705 | 83.5% | |
| 1 | 42896 | 16.5% |
plan_configuration_a
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 252 |
| Value | Count | Frequency (%) | |
| 0 | 260349 | 99.9% | |
| 1 | 252 | 0.1% |
plan_configuration_c
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 325 |
| Value | Count | Frequency (%) | |
| 0 | 260276 | 99.9% | |
| 1 | 325 | 0.1% |
plan_configuration_d
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 | 10529 |
| Value | Count | Frequency (%) | |
| 1 | 250072 | 96.0% | |
| 0 | 10529 | 4.0% |
plan_configuration_f
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 22 |
| Value | Count | Frequency (%) | |
| 0 | 260579 | > 99.9% | |
| 1 | 22 | < 0.1% |
plan_configuration_m
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 46 |
| Value | Count | Frequency (%) | |
| 0 | 260555 | > 99.9% | |
| 1 | 46 | < 0.1% |
plan_configuration_n
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 38 |
| Value | Count | Frequency (%) | |
| 0 | 260563 | > 99.9% | |
| 1 | 38 | < 0.1% |
plan_configuration_o
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 159 |
| Value | Count | Frequency (%) | |
| 0 | 260442 | 99.9% | |
| 1 | 159 | 0.1% |
plan_configuration_q
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 5692 |
| Value | Count | Frequency (%) | |
| 0 | 254909 | 97.8% | |
| 1 | 5692 | 2.2% |
plan_configuration_s
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 346 |
| Value | Count | Frequency (%) | |
| 0 | 260255 | 99.9% | |
| 1 | 346 | 0.1% |
plan_configuration_u
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 3649 |
| Value | Count | Frequency (%) | |
| 0 | 256952 | 98.6% | |
| 1 | 3649 | 1.4% |
legal_ownership_status_a
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 5512 |
| Value | Count | Frequency (%) | |
| 0 | 255089 | 97.9% | |
| 1 | 5512 | 2.1% |
legal_ownership_status_r
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 1473 |
| Value | Count | Frequency (%) | |
| 0 | 259128 | 99.4% | |
| 1 | 1473 | 0.6% |
legal_ownership_status_v
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 1 | |
|---|---|
| 0 | 9662 |
| Value | Count | Frequency (%) | |
| 1 | 250939 | 96.3% | |
| 0 | 9662 | 3.7% |
legal_ownership_status_w
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 254.5 KiB |
| 0 | |
|---|---|
| 1 | 2677 |
| Value | Count | Frequency (%) | |
| 0 | 257924 | 99.0% | |
| 1 | 2677 | 1.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| building_id | geo_level_1_id | geo_level_2_id | geo_level_3_id | count_floors_pre_eq | age | area_percentage | height_percentage | has_superstructure_adobe_mud | has_superstructure_mud_mortar_stone | has_superstructure_stone_flag | has_superstructure_cement_mortar_stone | has_superstructure_mud_mortar_brick | has_superstructure_cement_mortar_brick | has_superstructure_timber | has_superstructure_bamboo | has_superstructure_rc_non_engineered | has_superstructure_rc_engineered | has_superstructure_other | count_families | has_secondary_use | has_secondary_use_agriculture | has_secondary_use_hotel | has_secondary_use_rental | has_secondary_use_institution | has_secondary_use_school | has_secondary_use_industry | has_secondary_use_health_post | has_secondary_use_gov_office | has_secondary_use_use_police | has_secondary_use_other | damage_grade | land_surface_condition_n | land_surface_condition_o | land_surface_condition_t | foundation_type_h | foundation_type_i | foundation_type_r | foundation_type_u | foundation_type_w | roof_type_n | roof_type_q | roof_type_x | ground_floor_type_f | ground_floor_type_m | ground_floor_type_v | ground_floor_type_x | ground_floor_type_z | other_floor_type_j | other_floor_type_q | other_floor_type_s | other_floor_type_x | position_j | position_o | position_s | position_t | plan_configuration_a | plan_configuration_c | plan_configuration_d | plan_configuration_f | plan_configuration_m | plan_configuration_n | plan_configuration_o | plan_configuration_q | plan_configuration_s | plan_configuration_u | legal_ownership_status_a | legal_ownership_status_r | legal_ownership_status_v | legal_ownership_status_w | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 802906 | 6 | 487 | 12198 | 2 | 30 | 6 | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 1 | 28830 | 8 | 900 | 2812 | 2 | 10 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 2 | 94947 | 21 | 363 | 8973 | 2 | 10 | 5 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 3 | 590882 | 22 | 418 | 10694 | 2 | 10 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 4 | 201944 | 11 | 131 | 1488 | 3 | 30 | 8 | 9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 5 | 333020 | 8 | 558 | 6089 | 2 | 10 | 9 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 6 | 728451 | 9 | 475 | 12066 | 2 | 25 | 3 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 7 | 475515 | 20 | 323 | 12236 | 2 | 0 | 8 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 |
| 8 | 441126 | 0 | 757 | 7219 | 2 | 15 | 8 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 9 | 989500 | 26 | 886 | 994 | 1 | 0 | 13 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
Last rows
| building_id | geo_level_1_id | geo_level_2_id | geo_level_3_id | count_floors_pre_eq | age | area_percentage | height_percentage | has_superstructure_adobe_mud | has_superstructure_mud_mortar_stone | has_superstructure_stone_flag | has_superstructure_cement_mortar_stone | has_superstructure_mud_mortar_brick | has_superstructure_cement_mortar_brick | has_superstructure_timber | has_superstructure_bamboo | has_superstructure_rc_non_engineered | has_superstructure_rc_engineered | has_superstructure_other | count_families | has_secondary_use | has_secondary_use_agriculture | has_secondary_use_hotel | has_secondary_use_rental | has_secondary_use_institution | has_secondary_use_school | has_secondary_use_industry | has_secondary_use_health_post | has_secondary_use_gov_office | has_secondary_use_use_police | has_secondary_use_other | damage_grade | land_surface_condition_n | land_surface_condition_o | land_surface_condition_t | foundation_type_h | foundation_type_i | foundation_type_r | foundation_type_u | foundation_type_w | roof_type_n | roof_type_q | roof_type_x | ground_floor_type_f | ground_floor_type_m | ground_floor_type_v | ground_floor_type_x | ground_floor_type_z | other_floor_type_j | other_floor_type_q | other_floor_type_s | other_floor_type_x | position_j | position_o | position_s | position_t | plan_configuration_a | plan_configuration_c | plan_configuration_d | plan_configuration_f | plan_configuration_m | plan_configuration_n | plan_configuration_o | plan_configuration_q | plan_configuration_s | plan_configuration_u | legal_ownership_status_a | legal_ownership_status_r | legal_ownership_status_v | legal_ownership_status_w | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 260591 | 560805 | 20 | 368 | 5980 | 1 | 25 | 5 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260592 | 207683 | 10 | 1382 | 1903 | 2 | 25 | 5 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260593 | 226421 | 8 | 767 | 8613 | 2 | 5 | 13 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260594 | 159555 | 27 | 181 | 1537 | 6 | 0 | 13 | 12 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260595 | 827012 | 8 | 268 | 4718 | 2 | 20 | 8 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260596 | 688636 | 25 | 1335 | 1621 | 1 | 55 | 6 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260597 | 669485 | 17 | 715 | 2060 | 2 | 0 | 6 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260598 | 602512 | 17 | 51 | 8163 | 3 | 55 | 6 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260599 | 151409 | 26 | 39 | 1851 | 2 | 10 | 14 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 260600 | 747594 | 21 | 9 | 9101 | 3 | 10 | 7 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |